package org.example.backend.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.example.backend.entity.GbLabel;
import org.example.backend.entity.ZxLabel;

import java.util.List;

@Mapper
public interface LabelMapper {
    
    @Select("SELECT tag_number, tag_name FROM gb_industry_1_labels_table ORDER BY tag_number")
    List<GbLabel> selectGbIndustry1Labels();
    
    @Select("SELECT tag_name, gb_industry_1, gb_industry_2 FROM gb_industry_2_labels_table ORDER BY gb_industry_1, gb_industry_2")
    List<GbLabel> selectGbIndustry2Labels();
    
    @Select("SELECT tag_number, tag_name FROM zx_industry_1_labels_table ORDER BY tag_number")
    List<ZxLabel> selectZxIndustry1Labels();
    
    @Select("SELECT tag_name, zx_policy_1, zx_policy_2 FROM zx_industry_2_labels_table ORDER BY zx_policy_1, zx_policy_2")
    List<ZxLabel> selectZxIndustry2Labels();
}
